In [1]:
#Installation step 
!pip install pandas-profiling
#or 
#import sys
#!{sys.executable} -m pip install pandas-profiling
Requirement already satisfied: pandas-profiling in c:\users\syeda\anaconda3\lib\site-packages (3.0.0)
Requirement already satisfied: PyYAML>=5.0.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (5.4.1)
Requirement already satisfied: pydantic>=1.8.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.8.2)
Requirement already satisfied: scipy>=1.4.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.6.2)
Requirement already satisfied: matplotlib>=3.2.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (3.3.4)
Requirement already satisfied: phik>=0.11.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.12.0)
Requirement already satisfied: visions[type_image_path]==0.7.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.7.1)
Requirement already satisfied: numpy>=1.16.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.20.1)
Requirement already satisfied: tqdm>=4.48.2 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (4.59.0)
Requirement already satisfied: seaborn>=0.10.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.11.1)
Requirement already satisfied: requests>=2.24.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (2.25.1)
Requirement already satisfied: jinja2>=2.11.1 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (2.11.3)
Requirement already satisfied: tangled-up-in-unicode==0.1.0 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.1.0)
Requirement already satisfied: missingno>=0.4.2 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.5.0)
Requirement already satisfied: htmlmin>=0.1.12 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (0.1.12)
Requirement already satisfied: joblib in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.0.1)
Requirement already satisfied: pandas!=1.0.0,!=1.0.1,!=1.0.2,!=1.1.0,>=0.25.3 in c:\users\syeda\anaconda3\lib\site-packages (from pandas-profiling) (1.2.4)
Requirement already satisfied: bottleneck in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (1.3.2)
Requirement already satisfied: attrs>=19.3.0 in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (20.3.0)
Requirement already satisfied: multimethod==1.4 in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (1.4)
Requirement already satisfied: networkx>=2.4 in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (2.5)
Requirement already satisfied: Pillow in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (8.2.0)
Requirement already satisfied: imagehash in c:\users\syeda\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.1->pandas-profiling) (4.2.1)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\syeda\anaconda3\lib\site-packages (from jinja2>=2.11.1->pandas-profiling) (1.1.1)
Requirement already satisfied: cycler>=0.10 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (0.10.0)
Requirement already satisfied: python-dateutil>=2.1 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (2.8.1)
Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (2.4.7)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\users\syeda\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling) (1.3.1)
Requirement already satisfied: six in c:\users\syeda\anaconda3\lib\site-packages (from cycler>=0.10->matplotlib>=3.2.0->pandas-profiling) (1.15.0)
Requirement already satisfied: decorator>=4.3.0 in c:\users\syeda\anaconda3\lib\site-packages (from networkx>=2.4->visions[type_image_path]==0.7.1->pandas-profiling) (5.0.6)
Requirement already satisfied: pytz>=2017.3 in c:\users\syeda\anaconda3\lib\site-packages (from pandas!=1.0.0,!=1.0.1,!=1.0.2,!=1.1.0,>=0.25.3->pandas-profiling) (2021.1)
Requirement already satisfied: typing-extensions>=3.7.4.3 in c:\users\syeda\anaconda3\lib\site-packages (from pydantic>=1.8.1->pandas-profiling) (3.7.4.3)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (1.26.4)
Requirement already satisfied: chardet<5,>=3.0.2 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (4.0.0)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (2020.12.5)
Requirement already satisfied: idna<3,>=2.5 in c:\users\syeda\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling) (2.10)
Requirement already satisfied: PyWavelets in c:\users\syeda\anaconda3\lib\site-packages (from imagehash->visions[type_image_path]==0.7.1->pandas-profiling) (1.1.1)
In [2]:
import pandas_profiling
import pandas as pd
In [3]:
df = pd.read_csv('C:/Users/syeda/Downloads/match_data.csv')
In [4]:
df.head()
Out[4]:
id season city date team1 team2 toss_winner toss_decision winner eliminator ... overs player_of_match venue umpire1 umpire2 umpire3 first_bat_team first_bowl_team first_bat_score second_bat_score
0 419164 2010 Mumbai 2010-04-24 Royal Challengers Bangalore Deccan Chargers Deccan Chargers bat Royal Challengers Bangalore NaN ... 20 A Kumble Dr DY Patil Sports Academy RE Koertzen SJA Taufel NaN Deccan Chargers Royal Challengers Bangalore 82.0 86.0
1 419131 2010 Delhi 2010-03-29 Delhi Daredevils Kolkata Knight Riders Delhi Daredevils bat Delhi Daredevils NaN ... 20 DA Warner Feroz Shah Kotla SS Hazare SJA Taufel NaN Delhi Daredevils Kolkata Knight Riders 177.0 137.0
2 336021 2008 Mumbai 2008-05-16 Mumbai Indians Kolkata Knight Riders Mumbai Indians field Mumbai Indians NaN ... 20 SM Pollock Wankhede Stadium BR Doctrove DJ Harper NaN Kolkata Knight Riders Mumbai Indians 67.0 68.0
3 980931 2016 Pune 2016-04-22 Rising Pune Supergiants Royal Challengers Bangalore Rising Pune Supergiants field Royal Challengers Bangalore NaN ... 20 AB de Villiers Maharashtra Cricket Association Stadium CB Gaffaney VK Sharma NaN Royal Challengers Bangalore Rising Pune Supergiants 185.0 172.0
4 419163 2010 Mumbai 2010-04-22 Chennai Super Kings Deccan Chargers Chennai Super Kings bat Chennai Super Kings NaN ... 20 DE Bollinger Dr DY Patil Sports Academy BR Doctrove RB Tiffin NaN Chennai Super Kings Deccan Chargers 142.0 104.0

5 rows × 24 columns

In [5]:
#Getting the pandas profiling report 
pandas_profiling.ProfileReport(df)
Out[5]: